﻿/**
AIGIS
50%, 11/3/2014 change to  16/12/2010 
38%, 11/3/2014 change to  3/10/2011
**/
if upper(db_name()) = 'AIGISDB'
begin
	update	Payment set ExecuteDate='2010-12-16' 
	where	CONVERT(varchar(10), ExecuteDate,126) ='2014-03-11' and percentage=50;
	update Payment set ExecuteDate='2010-10-3' 
	where	CONVERT(varchar(10), ExecuteDate,126)='2014-03-11' and percentage=38;
end
go

